🎖️GitЯра🎖️
Node / meshtastic / Meshtastic-Android / files / core / database / src / commonMain / kotlin / org / meshtastic / core / database / dao / PacketDao.kt
Displaying Raw • Download
core/database/src/commonMain/kotlin/org/meshtastic/core/database/dao/PacketDao.kt 878905aea3776316a2dbed2e441a2c4a16a8eba4 (878905ae) Text, 17.98 KB
T8b949e/*
* Copyright (c) 2025-2026 Meshtastic LLC
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
Tff7b72package T7ee787org.meshtastic.core.database.dao
Tff7b72import T7ee787androidx.paging.PagingSource
Tff7b72import T7ee787androidx.room3.Dao
Tff7b72import T7ee787androidx.room3.Insert
Tff7b72import T7ee787androidx.room3.MapColumn
Tff7b72import T7ee787androidx.room3.OnConflictStrategy
Tff7b72import T7ee787androidx.room3.Query
Tff7b72import T7ee787androidx.room3.Transaction
Tff7b72import T7ee787androidx.room3.Update
Tff7b72import T7ee787androidx.room3.Upsert
Tff7b72import T7ee787kotlinx.coroutines.flow.Flow
Tff7b72import T7ee787okio.ByteString
Tff7b72import T7ee787org.meshtastic.core.common.util.nowMillis
Tff7b72import T7ee787org.meshtastic.core.database.entity.ContactSettings
Tff7b72import T7ee787org.meshtastic.core.database.entity.Packet
Tff7b72import T7ee787org.meshtastic.core.database.entity.PacketEntity
Tff7b72import T7ee787org.meshtastic.core.database.entity.ReactionEntity
Tff7b72import T7ee787org.meshtastic.core.model.DataPacket
Tff7b72import T7ee787org.meshtastic.core.model.MessageStatus
Tff7b72import T7ee787org.meshtastic.proto.ChannelSettings
Tf0883e@SuppressTb4b4b4(Ta5d6ff"Ta5d6ffTooManyFunctionsTa5d6ff"Tb4b4b4)
Tf0883e@Dao
Tff7b72interface T56d364PacketDao Tb4b4b4{
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = :portNum
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetAllPacketsTb4b4b4(Te6edf3portNumTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND filtered = 0
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetContactKeysTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<
Te6edf3MapTff7b72<
Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4)
Tffa657StringTb4b4b4,
Te6edf3PacketTb4b4b4,
Tff7b72>Tb4b4b4,
Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT p.* FROM packet p
INNER JOIN (
SELECT contact_key, MAX(received_time) as max_time
FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND filtered = 0
GROUP BY contact_key
) latest ON p.contact_key = latest.contact_key AND p.received_time = latest.max_time
WHERE (p.myNodeNum = 0 OR p.myNodeNum = (SELECT myNodeNum FROM my_node))
AND p.port_num = 1 AND p.filtered = 0
GROUP BY p.contact_key
ORDER BY p.received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetContactKeysPagedTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3PagingSourceTff7b72<Tffa657IntTb4b4b4, Te6edf3PacketTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetMessageCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND filtered = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND filtered = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetUnreadCountFlowTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT uuid FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND filtered = 0
ORDER BY received_time ASC
LIMIT 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetFirstUnreadMessageUuidTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657Long?Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) > 0 FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND filtered = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffhasUnreadMessagesTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657BooleanTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND read = 0 AND filtered = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetUnreadCountTotalTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff UPDATE packet
SET read = 1
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND filtered = 0 AND received_time <= :timestamp
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffclearUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3timestampTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff UPDATE packet
SET read = 1
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND read = 0 AND filtered = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffclearAllUnreadCountsTb4b4b4(Tb4b4b4)
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>Tff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
LIMIT :limit
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3limitTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>Tff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
AND (filtered = 0 OR :includeFiltered = 1)
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3includeFilteredTb4b4b4: Tffa657BooleanTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>Tff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromPagedTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3PagingSourceTff7b72<Tffa657IntTb4b4b4, Te6edf3PacketEntityTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND data = :data
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindDataPacketTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid in (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff DELETE FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND contact_key IN (:contactList)
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteContactsTb4b4b4(Te6edf3contactListTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid=:uuidTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteTb4b4b4(Te6edf3uuidTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4) Tb4b4b4{
Te6edf3deleteTb4b4b4(Te6edf3packetTb4b4b4.Te6edf3uuidTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT packet_id FROM packet WHERE uuid IN (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff DELETE FROM reactions
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND reply_id IN (:packetIds)
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>Tb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3packetIds Tff7b72= Te6edf3getPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4)
Tff7b72if Tb4b4b4(Te6edf3packetIdsTb4b4b4.Te6edf3isNotEmptyTb4b4b4(Tb4b4b4)Tb4b4b4) Tb4b4b4{
Te6edf3deleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4)
Tb4b4b4}
Te6edf3deletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageStatusTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3mTb4b4b4: Te6edf3MessageStatusTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3status Tff7b72= Te6edf3mTb4b4b4)
T8b949e// Match on key fields that identify the packet, rather than the entire data object
Te6edf3findPacketsWithIdTb4b4b4(Te6edf3dataTb4b4b4.Te6edf3idTb4b4b4)
Tb4b4b4.Te6edf3find Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3id Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3id Tff7b72&Tff7b72& Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3from Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3from Tff7b72&Tff7b72& Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3to Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3to Tb4b4b4}
Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageIdTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3id Tff7b72= Te6edf3idTb4b4b4)
T8b949e// Match on key fields that identify the packet
Te6edf3findPacketsWithIdTb4b4b4(Te6edf3dataTb4b4b4.Te6edf3idTb4b4b4)
Tb4b4b4.Te6edf3find Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3id Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3id Tff7b72&Tff7b72& Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3from Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3from Tff7b72&Tff7b72& Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3to Tff7b72=Tff7b72= Te6edf3dataTb4b4b4.Te6edf3to Tb4b4b4}
Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4, Te6edf3packetId Tff7b72= Te6edf3idTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT data FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetDataPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND packet_id = :requestId
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByIdTb4b4b4(Te6edf3requestIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE packet_id = :packetId
AND (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
LIMIT 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByPacketIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3PacketEntity?
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE packet_id IN (:packetIds)
AND (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketsByPacketIdsTb4b4b4(Te6edf3packetIdsTb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE packet_id = :packetId
AND (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindPacketsWithIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND substr(sfpp_hash, 1, 8) = substr(:hash, 1, 8)
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindPacketBySfppHashTb4b4b4(Te6edf3hashTb4b4b4: Te6edf3ByteStringTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT data FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND json_extract(data, 'Tffd700${Ta5d6ff"$Ta5d6ff"Tffd700}Ta5d6ff.status') = 'QUEUED'
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetQueuedPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 8
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteWaypointTb4b4b4(Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3uuidList Tff7b72= Te6edf3getAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3waypointTff7b72?.Te6edf3id Tff7b72=Tff7b72= Te6edf3id Tb4b4b4}Tb4b4b4.Te6edf3map Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3uuid Tb4b4b4}
Te6edf3deleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settingsTa5d6ff"Tb4b4b4)
Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<
Te6edf3MapTff7b72<
Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4)
Tffa657StringTb4b4b4,
Te6edf3ContactSettingsTb4b4b4,
Tff7b72>Tb4b4b4,
Tff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settings WHERE contact_key = :contactTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3ContactSettings?
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffupsertContactSettingsTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ContactSettingsTff7b72>Tb4b4b4)
Tf0883e@InsertTb4b4b4(Te6edf3onConflict Tff7b72= Te6edf3OnConflictStrategyTb4b4b4.Te6edf3IGNORETb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffinsertContactSettingsIgnoreTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ContactSettingsTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffUPDATE contact_settings SET muteUntil = :muteUntil WHERE contact_key IN (:contactKeys)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffupdateMuteUntilTb4b4b4(Te6edf3contactKeysTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4, Te6edf3muteUntilTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffsetMuteUntilTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4, Te6edf3untilTb4b4b4: Tffa657LongTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3absoluteMuteUntil Tff7b72=
Tff7b72when Tb4b4b4{
Te6edf3until Tff7b72=Tff7b72= Tffa657LongTb4b4b4.Te6edf3MAX_VALUE Tff7b72-Tff7b72> Tffa657LongTb4b4b4.Te6edf3MAX_VALUE
Te6edf3until Tff7b72=Tff7b72= T79c0ff0L Tff7b72-Tff7b72> T79c0ff0L
Tff7b72else Tff7b72-Tff7b72> Te6edf3nowMillis Tff7b72+ Te6edf3until
Tb4b4b4}
T8b949e// Ensure rows exist for all contacts (IGNORE avoids overwriting existing data)
Te6edf3insertContactSettingsIgnoreTb4b4b4(Te6edf3contactsTb4b4b4.Te6edf3map Tb4b4b4{ Te6edf3ContactSettingsTb4b4b4(Te6edf3contact_key Tff7b72= Tffa657itTb4b4b4) Tb4b4b4}Tb4b4b4)
T8b949e// Atomic column-level update — no read-then-write race
Te6edf3updateMuteUntilTb4b4b4(Te6edf3contactsTb4b4b4, Te6edf3absoluteMuteUntilTb4b4b4)
Tb4b4b4}
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3reactionTb4b4b4: Te6edf3ReactionEntityTb4b4b4)
Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateTb4b4b4(Te6edf3reactionTb4b4b4: Te6edf3ReactionEntityTb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM reactions
WHERE packet_id = :packetId
AND (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindReactionsWithIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3ReactionEntityTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM reactions
WHERE packet_id = :packetId
AND (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
LIMIT 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetReactionByPacketIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3ReactionEntity?
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM reactions
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND substr(sfpp_hash, 1, 8) = substr(:hash, 1, 8)
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindReactionBySfppHashTb4b4b4(Te6edf3hashTb4b4b4: Te6edf3ByteStringTb4b4b4)Tb4b4b4: Te6edf3ReactionEntity?
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND filtered = 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetFilteredCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND filtered = 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetFilteredCountFlowTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657IntTff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
AND (filtered = 0 OR :includeFiltered = 1)
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromPagedTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3includeFilteredTb4b4b4: Tffa657BooleanTb4b4b4)Tb4b4b4: Te6edf3PagingSourceTff7b72<Tffa657IntTb4b4b4, Te6edf3PacketEntityTff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT filtering_disabled FROM contact_settings WHERE contact_key = :contactTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetContactFilteringDisabledTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Boolean?
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffsetContactFilteringDisabledTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3disabledTb4b4b4: Tffa657BooleanTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3settings Tff7b72=
Te6edf3getContactSettingsTb4b4b4(Te6edf3contactTb4b4b4)Tff7b72?.Te6edf3copyTb4b4b4(Te6edf3filteringDisabled Tff7b72= Te6edf3disabledTb4b4b4)
Tff7b72?: Te6edf3ContactSettingsTb4b4b4(Te6edf3contact_key Tff7b72= Te6edf3contactTb4b4b4, Te6edf3filteringDisabled Tff7b72= Te6edf3disabledTb4b4b4)
Te6edf3upsertContactSettingsTb4b4b4(Te6edf3listOfTb4b4b4(Te6edf3settingsTb4b4b4)Tb4b4b4)
Tb4b4b4}
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllTb4b4b4(Tb4b4b4) Tb4b4b4{
Te6edf3deleteAllPacketsTb4b4b4(Tb4b4b4)
Te6edf3deleteAllReactionsTb4b4b4(Tb4b4b4)
Te6edf3deleteAllContactSettingsTb4b4b4(Tb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packetTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllPacketsTb4b4b4(Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM reactionsTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllReactionsTb4b4b4(Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM contact_settingsTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllContactSettingsTb4b4b4(Tb4b4b4)
T8b949e/**
* One-time migration: Remap all message DataPacket.channel indices to new mapping using PSK after a channel
* reorder. For each Packet (with port_num = 1), finds the old PSK then sets the channel index to the matching
* newSettings index. Skips if PSKs do not match or are missing.
*/
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffmigrateChannelsByPSKTb4b4b4(Te6edf3oldSettingsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ChannelSettingsTff7b72>Tb4b4b4, Te6edf3newSettingsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ChannelSettingsTff7b72>Tb4b4b4) Tb4b4b4{
T8b949e// Pre-calculate mapping from old index to new index
Tff7b72val Te6edf3indexMap Tff7b72=
Te6edf3oldSettings
Tb4b4b4.Te6edf3mapIndexed Tb4b4b4{ Te6edf3oldIndexTb4b4b4, Te6edf3oldChannel Tff7b72-Tff7b72>
Tff7b72val Te6edf3pskMatches Tff7b72=
Te6edf3newSettingsTb4b4b4.Te6edf3mapIndexedNotNull Tb4b4b4{ Te6edf3indexTb4b4b4, Te6edf3channel Tff7b72-Tff7b72>
Tff7b72if Tb4b4b4(Te6edf3channelTb4b4b4.Te6edf3psk Tff7b72=Tff7b72= Te6edf3oldChannelTb4b4b4.Te6edf3pskTb4b4b4) Te6edf3index Te6edf3to Te6edf3channel Tff7b72else Tff7b72null
Tb4b4b4}
Tff7b72val Te6edf3newIndex Tff7b72=
Tff7b72when Tb4b4b4{
Te6edf3pskMatchesTb4b4b4.Te6edf3isEmptyTb4b4b4(Tb4b4b4) Tff7b72-Tff7b72> Tff7b72null
Te6edf3pskMatchesTb4b4b4.Te6edf3size Tff7b72=Tff7b72= T79c0ff1 Tff7b72-Tff7b72> Te6edf3pskMatchesTb4b4b4.Te6edf3firstTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3first
Tff7b72else Tff7b72-Tff7b72> Tb4b4b4{
T8b949e// Multiple matches with same PSK. Disambiguate by Name.
Tff7b72val Te6edf3nameMatches Tff7b72= Te6edf3pskMatchesTb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3secondTb4b4b4.Te6edf3name Tff7b72=Tff7b72= Te6edf3oldChannelTb4b4b4.Te6edf3name Tb4b4b4}
Tff7b72if Tb4b4b4(Te6edf3nameMatchesTb4b4b4.Te6edf3size Tff7b72=Tff7b72= T79c0ff1Tb4b4b4) Tb4b4b4{
Te6edf3nameMatchesTb4b4b4.Te6edf3firstTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3first
Tb4b4b4} Tff7b72else Tb4b4b4{
T8b949e// Still ambiguous. Prefer keeping same index.
Te6edf3pskMatchesTb4b4b4.Te6edf3find Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3first Tff7b72=Tff7b72= Te6edf3oldIndex Tb4b4b4}Tff7b72?.Te6edf3first Tff7b72?: Te6edf3pskMatchesTb4b4b4.Te6edf3firstTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3first
Tb4b4b4}
Tb4b4b4}
Tb4b4b4}
Te6edf3oldIndex Te6edf3to Te6edf3newIndex
Tb4b4b4}
Tb4b4b4.Te6edf3toMapTb4b4b4(Tb4b4b4)
Tff7b72val Te6edf3allPackets Tff7b72= Te6edf3getAllUserPacketsForMigrationTb4b4b4(Tb4b4b4)
Tff7b72for Tb4b4b4(Te6edf3packet Tff7b72in Te6edf3allPacketsTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3oldIndex Tff7b72= Te6edf3packetTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3channel
Tff7b72val Te6edf3newIndex Tff7b72= Te6edf3indexMapTff7b72[Te6edf3oldIndexTff7b72]
Tff7b72if Tb4b4b4(Te6edf3newIndex Tff7b72!Tff7b72= Tff7b72null Tff7b72&Tff7b72& Te6edf3oldIndex Tff7b72!Tff7b72= Te6edf3newIndexTb4b4b4) Tb4b4b4{
T8b949e// Rebuild contact_key with the new index, keeping the rest unchanged
Tff7b72val Te6edf3oldKeySuffix Tff7b72= Te6edf3packetTb4b4b4.Te6edf3contact_keyTb4b4b4.Te6edf3dropWhile Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3isDigitTb4b4b4(Tb4b4b4) Tb4b4b4}
Tff7b72val Te6edf3newContactKey Tff7b72= Ta5d6ff"Tffd700$Te6edf3newIndexTffd700$Te6edf3oldKeySuffixTa5d6ff"
Te6edf3updateTb4b4b4(Te6edf3packetTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3contact_key Tff7b72= Te6edf3newContactKeyTb4b4b4, Te6edf3data Tff7b72= Te6edf3packetTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3channel Tff7b72= Te6edf3newIndexTb4b4b4)Tb4b4b4)Tb4b4b4)
Tb4b4b4}
Tb4b4b4}
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM packet WHERE port_num = 1Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetAllUserPacketsForMigrationTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tf0883e@SuppressTb4b4b4(Ta5d6ff"Ta5d6ffMaxLineLengthTa5d6ff"Tb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"Ta5d6ffUPDATE packet SET filtered = :filtered WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node)) AND data LIKE :senderIdPatternTa5d6ff"Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffupdateFilteredBySenderTb4b4b4(Te6edf3senderIdPatternTb4b4b4: Tffa657StringTb4b4b4, Te6edf3filteredTb4b4b4: Tffa657BooleanTb4b4b4)
Tb4b4b4}
Served by rngit 1.5.0 - Generated in 0.1s